Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.1 Apply Cell Ranges and References in Formulas and Functions: Define Order of Operations Evaluate Formulas You can evaluate formulas in Microsoft Excel. The little formula auditing tool has some interesting capabilities. 3. Consider This: Evaluate Formula In this example, the formula refers to several cells that are calculated in a different spreadsheet. When a cell reference, such as Cell H11, is highlighted, you can Step Into the cell and look at the formula that goes with it.   Way cool technology. Example of a formula we created earlier in Microsoft Excel